﻿CREATE TABLE [dbo].[DataFileLog] (
    [Id]                   INT              IDENTITY (1, 1) NOT NULL,
    [DatabaseFileLogSetId] UNIQUEIDENTIFIER NULL,
    [InstanceName]         NVARCHAR (50)    NULL,
    [DatabaseName]         NVARCHAR (255)   NULL,
    [GroupId]              INT              NULL,
    [FileId]               INT              NULL,
    [FileGuid]             UNIQUEIDENTIFIER NULL,
    [FileTypeDesc]         NVARCHAR (50)    NULL,
    [FileName]             NVARCHAR (255)   NULL,
    [FilePath]             NVARCHAR (255)   NULL,
    [SizeInMb]             BIGINT           NULL,
    [MaxSizeInMb]          BIGINT           NULL,
    [GrowthInPercent]      INT              NULL,
    [GrowthInMb]           BIGINT           NULL,
    [OwnerSid]             NVARCHAR (50)    NULL,
    [CreateDate]           DATETIME         NULL,
    [CompatibilityLevel]   INT              NULL,
    [CollationName]        NVARCHAR (255)   NULL,
    [UserAccessDesc]       NVARCHAR (255)   NULL,
    [IsReadOnly]           INT              NULL,
    [IsAutoCloseOn]        INT              NULL,
    [IsAutoShrinkOn]       INT              NULL,
    [StateDesc]            NVARCHAR (255)   NULL,
    [RecoveryModelDesc]    NVARCHAR (255)   NULL,
    [LastModifiedDate]     DATETIME         CONSTRAINT [DF_DataFileLog_LastModifiedDate] DEFAULT (getdate()) NOT NULL,
    CONSTRAINT [PK_DataFileLog] PRIMARY KEY CLUSTERED ([Id] ASC)
);

